declare @OLDFNumber nvarchar(max),@NEWFNumber nvarchar(max)
set @OLDFNumber='10.105'
set @NEWFNumber='07.091'
select * from t_RP_Bill t1
left join t_Supplier t2
on t1.FAnaItem=t2.FItemID
where t2.FNumber=@OLDFNumber

select * from t_rp_BegData t1
left join t_Supplier t2
on t1.FComID=t2.FItemID
where t2.FNumber=@OLDFNumber

select * from ICStockBill t1
left join t_Supplier t2
on t1.FSupplyID=t2.FItemID
where t2.FNumber=@OLDFNumber

select * from t_rp_contact t1
left join t_Supplier t2
on t1.FCustomer=t2.FItemID
where t2.FNumber=@OLDFNumber

select * from  t_rp_contactbal t1
left join t_Supplier t2
on t1.FCustomer=t2.FItemID
where t2.FNumber=@OLDFNumber